Re: [SQL] different between || and && in a statement
От | Herouth Maoz |
---|---|
Тема | Re: [SQL] different between || and && in a statement |
Дата | |
Msg-id | l03130303b43b69f1ad68@[147.233.159.109] обсуждение исходный текст |
Ответ на | different between || and && in a statement (guenther@laokoon.IN-Berlin.DE (Christian Guenther)) |
Список | pgsql-sql |
At 21:43 +0200 on 25/10/1999, Christian Guenther wrote: > Whats the different between the logical expression && and || and is there > a way to get && working? It's really not clear what you are trying to achieve here. Neither || nor && are logical operators. In Postgres, || is string concatenation, not "or". What you would get in sum(...) || sum( ... ) is the concatenation of the two sums. If one is 32 and the other 17, you'd get 3217. In any case, what sense does a logical operator have between two integers? Logical operators should connect between logical operands. But the sums are sums of integers. There is no such thing as a boolean sum. Unless you meant to do a cumulative "or" operation between all the rows that have the proper string value? In that case, you really have to build a custom aggregate for it. In any case, in SQL, the word for "or" is... OR. The word for "and" is AND and the word for "not" is NOT. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma
В списке pgsql-sql по дате отправления: